package cn.edu.niit.alienlab.jshttplessonserver.dao;

import cn.edu.niit.alienlab.jshttplessonserver.domain.CompanyInfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface CompanyInfoDao {


    /*按影片id查询出行信息*/
    @Select("SELECT ci.*,mc.movie_id FROM company_info ci,movie_companies mc " +
            "where mc.company_id=ci.id and mc.company_type='发行公司' " +
            "AND mc.movie_id=#{movie_id}")
    public CompanyInfo selectCompanyInfoByMovieId(Integer movie_id);

}
